package com.itheima.mall.dubbo.mapper.pms;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.mall.entity.domain.pms.Product;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PmsProductMapper extends BaseMapper<Product> {
    @Select("select count(*) from pms_product")
    Long getTotal();

    List<Product> getDataByPage(@Param("begin") int begin,@Param("size") int size,@Param("keyword") String keyword,
                                                        @Param("brandId") Integer brandId,@Param("productCategoryId") Integer productCategoryId,
                                                        @Param("productSn") String productSn,@Param("publishStatus") Integer publishStatus,
                                                         @Param("verifyStatus")Integer verifyStatus);

}
